// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   file_garbage_ok.java

package draft.hr;

import include.get_sql.getInsertSql;
import include.nseer_cookie.Divide1;
import include.nseer_cookie.exchange;
import include.nseer_db.nseer_db_backup1;
import java.io.IOException;
import java.util.StringTokenizer;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;
import validata.ValidataTag;

public class file_garbage_ok extends HttpServlet
{

	ServletContext application;
	HttpSession session;
	nseer_db_backup1 erp_db;

	public file_garbage_ok()
	{
		erp_db = null;
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			java.io.PrintWriter out = response.getWriter();
			nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
			getInsertSql getInsertSql = new getInsertSql();
			ValidataTag vt = new ValidataTag();
			if (hr_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				String kind_chain = request.getParameter("kind_chain");
				String chain_id = Divide1.getId(kind_chain);
				String chain_name = Divide1.getName(kind_chain);
				String oldKind_chain = request.getParameter("oldKind_chain");
				String oldChain_id = Divide1.getId(oldKind_chain);
				String human_ID = request.getParameter("human_ID");
				String human_name = request.getParameter("human_name");
				String human_address = request.getParameter("human_address");
				String human_title_class = request.getParameter("human_title_class");
				String human_bank = request.getParameter("human_bank");
				String human_account = request.getParameter("human_account");
				String human_tel = request.getParameter("human_tel");
				String human_home_tel = request.getParameter("human_home_tel");
				String human_postcode = request.getParameter("human_postcode");
				String register = request.getParameter("register");
				String human_cellphone = request.getParameter("human_cellphone");
				String idcard = request.getParameter("idcard");
				String SIN = request.getParameter("SIN");
				String religion = request.getParameter("religion");
				String party = request.getParameter("party");
				String race = request.getParameter("race");
				String nationality = request.getParameter("nationality");
				String age = request.getParameter("age");
				String sex = request.getParameter("sex");
				String speciality = request.getParameter("speciality");
				String hobby = request.getParameter("hobby");
				String birthday = request.getParameter("birthday");
				if (birthday.equals(""))
					birthday = "1800-01-01";
				String birthplace = request.getParameter("birthplace");
				String human_email = request.getParameter("human_email");
				String educated_degree = request.getParameter("educated_degree");
				String educated_years = request.getParameter("educated_years");
				String educated_major = request.getParameter("educated_major");
				String register_time = request.getParameter("register_time");
				String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
				String remark = exchange.toHtml(bodyc);
				String bodya = new String(request.getParameter("history_records").getBytes("UTF-8"), "UTF-8");
				String history_records = exchange.toHtml(bodya);
				String bodyb = new String(request.getParameter("family_membership").getBytes("UTF-8"), "UTF-8");
				String family_membership = exchange.toHtml(bodyb);
				String salary_standard_ID = "";
				String salary_standard_name = "";
				String salary_sum = "";
				String salary_standard = request.getParameter("salary_standard");
				for (StringTokenizer tokenTO6 = new StringTokenizer(salary_standard, "/"); tokenTO6.hasMoreTokens();)
				{
					salary_standard_ID = tokenTO6.nextToken();
					salary_standard_name = tokenTO6.nextToken();
					salary_sum = tokenTO6.nextToken();
				}

				String column_group = getInsertSql.sql((String)dbSession.getAttribute("unit_db_name"), "hr_file");
				if (vt.validata((String)dbSession.getAttribute("unit_db_name"), "hr_file", "human_ID", human_ID, "check_tag").equals("5") || vt.validata((String)dbSession.getAttribute("unit_db_name"), "hr_file", "human_ID", human_ID, "check_tag").equals("9"))
					try
					{
						String sql8 = (new StringBuilder("update hr_file set chain_id='")).append(chain_id).append("',chain_name='").append(chain_name).append("',human_name='").append(human_name).append("',human_address='").append(human_address).append("',human_title_class='").append(human_title_class).append("',human_bank='").append(human_bank).append("',human_account='").append(human_account).append("',human_tel='").append(human_tel).append("',human_home_tel='").append(human_home_tel).append("',human_postcode='").append(human_postcode).append("',register='").append(register).append("',educated_degree='").append(educated_degree).append("',educated_years='").append(educated_years).append("',educated_major='").append(educated_major).append("',register_time='").append(register_time).append("',salary_standard_ID='").append(salary_standard_ID).append("',salary_standard_name='").append(salary_standard_name).append("',salary_sum='").append(salary_sum).append("',family_membership='").append(family_membership).append("',history_records='").append(history_records).append("',remark='").append(remark).append("',human_cellphone='").append(human_cellphone).append("',idcard='").append(idcard).append("',SIN='").append(SIN).append("',religion='").append(religion).append("',race='").append(race).append("',nationality='").append(nationality).append("',party='").append(party).append("',age='").append(age).append("',birthday='").append(birthday).append("',birthplace='").append(birthplace).append("',sex='").append(sex).append("',speciality='").append(speciality).append("',hobby='").append(hobby).append("',human_email='").append(human_email).append("',check_tag='2' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql8);
						if (!chain_id.equals("oldChain_id"))
						{
							sql8 = (new StringBuilder("update hr_config_file_kind set delete_tag='0' where file_id='")).append(oldChain_id).append("'").toString();
							hr_db.executeUpdate(sql8);
							sql8 = (new StringBuilder("update hr_config_file_kind set delete_tag='1' where file_id='")).append(chain_id).append("'").toString();
							hr_db.executeUpdate(sql8);
						}
						String sql9 = (new StringBuilder("update security_users set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql9);
						String sql10 = (new StringBuilder("update security_license set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql10);
						response.sendRedirect((new StringBuilder("draft/hr/file_choose_attachment.jsp?human_ID=")).append(human_ID).toString());
					}
					catch (Exception ex)
					{
						ex.printStackTrace();
					}
				else
					response.sendRedirect("draft/hr/file_ok.jsp?finished_tag=3");
				hr_db.commit();
				hr_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
